package com.chinaunicom.emergency.repository;

import com.chinaunicom.emergency.model.OauthClientDetails;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Query;
import org.springframework.stereotype.Repository;

import java.util.List;

/**
 * @Author liliang
 * @Date 2019/12/18 16:46
 * @Version 1.0
 */
@Repository
public interface OauthClientDetailsRepository extends JpaRepository<OauthClientDetails,String>, JpaSpecificationExecutor {

    @Query(nativeQuery = true, value = "select CLIENT_ID from oauth_client_details ")
    List<String> findClienIds();
}
